package com.uniquesoft.excelwriter;

import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;

import org.apache.poi.ss.util.CellRangeAddress;

/**
 * @author juliazhang
 *
 */
public class Sheet2 extends BaseSheet{
	
	/*
	 * sheet2 的表格
	 * **/
	public static final HashMap<String, CellRangeAddress> sheetFormat;
	static
	{
		sheetFormat = new HashMap<String,CellRangeAddress>();
		sheetFormat.put("rewards", new CellRangeAddress(1,1,2,7));//奖惩情况
		sheetFormat.put("annualAppraisal",new CellRangeAddress(2,2,2,7));//年度考核结果
		sheetFormat.put("removalReason",new CellRangeAddress(3,3,2,7));//任免理由
		sheetFormat.put("called",new CellRangeAddress(5,11,2,2));//家庭成员称谓
		sheetFormat.put("familyName",new CellRangeAddress(5,11,3,3));//家庭成员姓名
		sheetFormat.put("familyBirthDate",new CellRangeAddress(5,11,4,4));//家庭成员出生日期
		sheetFormat.put("familyPoliticalStatus",new CellRangeAddress(5,11,5,5));//家庭成员政治面貌
		sheetFormat.put("familyComPos",new CellRangeAddress(5,11,6,7));//家庭成员工作单位及职务
		sheetFormat.put("applicant",new CellRangeAddress(16,16,3,3));//填表人
	}
	
	/**
	 * @author juliazhang
	 * 家庭成员类
	 */
	public static class FamilyMember{ 
		String called;
		String familyName;
		/*String*/Date familyBirthDate;
		String familyPoliticalStatus;
		String familyComPos;
		/**
		 * @param called
		 * @param familyName
		 * @param familyBirthDate
		 * @param familyPoliticalStatus
		 * @param familyComPoS
		 */
		public FamilyMember(String called, String familyName, /*String*/Date familyBirthDate, String familyPoliticalStatus,
				String familyComPos) {
			super();
			this.called = called;
			this.familyName = familyName;
			this.familyBirthDate = familyBirthDate;
			this.familyPoliticalStatus = familyPoliticalStatus;
			this.familyComPos = familyComPos;
		}
		public String getCalled() {
			return called;
		}
		public void setCalled(String called) {
			this.called = called;
		}
		public String getFamilyName() {
			return familyName;
		}
		public void setFamilyName(String familyName) {
			this.familyName = familyName;
		}
		public Date getFamilyBirthDate() {
			return familyBirthDate;
		}
		public void setFamilyBirthDate(Date familyBirthDate) {
			this.familyBirthDate = familyBirthDate;
		}
		public String getFamilyPoliticalStatus() {
			return familyPoliticalStatus;
		}
		public void setFamilyPoliticalStatus(String familyPoliticalStatus) {
			this.familyPoliticalStatus = familyPoliticalStatus;
		}
		public String getFamilyComPos() {
			return familyComPos;
		}
		public void setFamilyComPos(String familyComPos) {
			this.familyComPos = familyComPos;
		}
		
		
		
	}
	
	private String rewards;
	private String annualAppraisal;
	private String removalReason;
	private ArrayList<FamilyMember> familyMembers ;
	private String applicant;
	
	
	public String getRewards() {
		return rewards;
	}
	public void setRewards(String rewards) {
		this.rewards = rewards;
	}
	public String getAnnualAppraisal() {
		return annualAppraisal;
	}
	public void setAnnualAppraisal(String annualAppraisal) {
		this.annualAppraisal = annualAppraisal;
	}
	public String getRemovalReason() {
		return removalReason;
	}
	public void setRemovalReason(String removalReason) {
		this.removalReason = removalReason;
	}
	public ArrayList<FamilyMember> getFamilyMembers() {
		return familyMembers;
	}
	public void setFamilyMembers(ArrayList<FamilyMember> familyMembers) {
		this.familyMembers = familyMembers;
	}
	public String getApplicant() {
		return applicant;
	}
	public void setApplicant(String applicant) {
		this.applicant = applicant;
	}
	
		
}
